package com.zyh.scs.admin.mapper.jd;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zyh.scs.admin.api.entity.jd.JdOrder;
import com.zyh.scs.admin.api.vo.account.BillJDAfterSalesExcelVO;
import com.zyh.scs.admin.api.vo.account.BillJDInfoExcelVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.time.LocalDateTime;
import java.util.List;

@Mapper
public interface JdOrderMapper extends BaseMapper<JdOrder> {


    /**
     * 京东订单明细sql
     *
     * @return
     */
    List<BillJDInfoExcelVO> getJDOrderList(@Param("beginTime")LocalDateTime beginTime, @Param("endTime") LocalDateTime endTime);


    /**
     * 京东售后明细sql
     *
     * @return
     */
    List<BillJDAfterSalesExcelVO> getJDAfterSaleList(@Param("beginTime")LocalDateTime beginTime, @Param("endTime") LocalDateTime endTime);


    /**
     * 通过退款id查询 商品编号和商品数量
     *
     * @return
     */
    BillJDAfterSalesExcelVO getJDRefundList(@Param("refundId") Long refundId);


}
